home *** CD-ROM | disk | FTP | other *** search
/ Archive Magazine CD 1995 / Archive Magazine CD 1995.iso / discs / prog_disc / volume_4 / issue_01 / pipeline / fry / gasuse < prev    next >
Encoding:
Text File  |  1990-07-28  |  17.7 KB  |  782 lines
  1. %OP%DEGas Consumption
  2. %OP%TNN
  3. %OP%DP0
  4. %OP%TM2
  5. %OP%HM0
  6. %OP%FM0
  7. %OP%BM0
  8. %OP%LM3
  9. %OP%FR0,4
  10. %CO:A,9,76%%C%Gas Consumption at Noddy's House - since 27 Nov 1975
  11.  
  12. Reading
  13.   Date
  14. %V%%R%27.11.75
  15. %V%%R%28.2.76
  16. %V%%R%1.4.76
  17. %V%%R%2.7.76
  18. %V%%R%29.9.76
  19. %V%%R%7.1.77
  20. %V%%R%5.4.77
  21. %V%%R%29.6.77
  22. %V%%R%4.10.77
  23. %V%%R%5.1.78
  24. %V%%R%11.4.78
  25. %V%%R%5.7.78
  26. %V%%R%29.9.78
  27. %V%%R%5.1.79
  28. %V%%R%5.4.79
  29. %V%%R%4.7.79
  30. %V%%R%28.9.79
  31. %V%%R%4.1.80
  32. %V%%R%1.4.80
  33. %V%%R%4.7.80
  34. %V%%R%30.9.80
  35. %V%%R%7.1.81
  36. %V%%R%31.3.81
  37. %V%%R%1.7.81
  38. %V%%R%6.10.81
  39. %V%%R%6.1.82
  40. %V%%R%6.4.82
  41. %V%%R%21.7.82
  42. %V%%R%6.10.82
  43. %V%%R%6.1.83
  44. %V%%R%11.4.83
  45. %V%%R%7.7.83
  46. %V%%R%21.10.83
  47. %V%%R%11.2.84
  48. %V%%R%6.4.84
  49. %V%%R%6.7.84
  50. %V%%R%3.10.84
  51. %V%%R%11.1.85
  52. %V%%R%22.7.85
  53. %V%%R%7.10.85
  54. %V%%R%3.1.86
  55. %V%%R%7.4.86
  56. %V%%R%7.7.86
  57. %V%%R%2.10.86
  58. %V%%R%5.1.87
  59. %V%%R%29.1.87
  60. %V%%R%4.4.87
  61. %V%%R%2.7.87
  62. %V%%R%8.10.87
  63. %V%%R%4.1.88
  64. %V%%R%7.4.88
  65. %V%%R%7.7.88
  66. %V%%R%2.10.88
  67. %V%%R%7.1.89
  68. %V%%R%4.4.89
  69. %V%%R%6.7.89
  70. %V%%R%12.10.89
  71. %V%%R%24.1.90
  72. %V%%R%8.4.90
  73. %V%%R%8.4.90
  74. %V%%R%5.7.90
  75. %CO:B,6,67%
  76.  
  77.  
  78. Meter
  79. %V%%R%%D0%662
  80. %V%%R%951
  81. %V%%R%1050
  82. %V%%R%1146
  83. %V%%R%1203
  84. %V%%R%1450
  85. %V%%R%1667
  86. %V%%R%1779
  87. %V%%R%1845
  88. %V%%R%2017
  89. %V%%R%2245
  90. %V%%R%2360
  91. %V%%R%2394
  92. %V%%R%2564
  93. %V%%R%2835
  94. %V%%R%2929
  95. %V%%R%2983
  96. %V%%R%3172
  97. %V%%R%3392
  98. %V%%R%3457
  99. %V%%R%3503
  100. %V%%R%3694
  101. %V%%R%3882
  102. %V%%R%3939
  103. %V%%R%3981
  104. %V%%R%4181
  105. %V%%R%4394
  106. %V%%R%4459
  107. %V%%R%4494
  108. %V%%R%4686
  109. %V%%R%4915
  110. %V%%R%4981
  111. %V%%R%5039
  112. %V%%R%5271
  113. %V%%R%5406
  114. %V%%R%5470
  115. %V%%R%5518
  116. %V%%R%5646
  117. %V%%R%5906
  118. %V%%R%5922
  119. %V%%R%6067
  120. %V%%R%6343
  121. %V%%R%6403
  122. %V%%R%6430
  123. %V%%R%6578
  124. %V%%R%6666
  125. %V%%R%6830
  126. %V%%R%6910
  127. %V%%R%6911
  128. %V%%R%7070
  129. %V%%R%7284
  130. %V%%R%7361
  131. %V%%R%7363
  132. %V%%R%7519
  133. %V%%R%7715
  134. %V%%R%7797
  135. %V%%R%7795
  136. %V%%R%7970
  137. %V%%R%8100
  138. %V%%R%0
  139. %V%%R%59
  140. %CO:C,6,61%
  141.  
  142.   100
  143. Cu.Ft
  144. %V%%R%0
  145. %V%%R%B6-B5
  146. %V%%R%B7-B6
  147. %V%%R%B8-B7
  148. %V%%R%B9-B8
  149. %V%%R%B10-B9
  150. %V%%R%B11-B10
  151. %V%%R%B12-B11
  152. %V%%R%B13-B12
  153. %V%%R%B14-B13
  154. %V%%R%B15-B14
  155. %V%%R%B16-B15
  156. %V%%R%B17-B16
  157. %V%%R%B18-B17
  158. %V%%R%B19-B18
  159. %V%%R%B20-B19
  160. %V%%R%B21-B20
  161. %V%%R%B22-B21
  162. %V%%R%B23-B22
  163. %V%%R%B24-B23
  164. %V%%R%B25-B24
  165. %V%%R%B26-B25
  166. %V%%R%B27-B26
  167. %V%%R%B28-B27
  168. %V%%R%B29-B28
  169. %V%%R%B30-B29
  170. %V%%R%B31-B30
  171. %V%%R%B32-B31
  172. %V%%R%B33-B32
  173. %V%%R%B34-B33
  174. %V%%R%B35-B34
  175. %V%%R%B36-B35
  176. %V%%R%B37-B36
  177. %V%%R%B38-B37
  178. %V%%R%B39-B38
  179. %V%%R%B40-B39
  180. %V%%R%B41-B40
  181. %V%%R%B42-B41
  182. %V%%R%B43-B42
  183. %V%%R%B44-B43
  184. %V%%R%B45-B44
  185. %V%%R%B46-B45
  186. %V%%R%B47-B46
  187. %V%%R%B48-B47
  188. %V%%R%B49-B48
  189. %V%%R%B50-B49
  190. %V%%R%B51-B50
  191. %V%%R%B52-B51
  192. %V%%R%B53-B52
  193. %V%%R%B54-B53
  194. %V%%R%B55-B54
  195. %V%%R%B56-B55
  196. %V%%R%B57-B56
  197. %V%%R%B58-B57
  198. %V%%R%B59-B58
  199. %V%%R%B60-B59
  200. %V%%R%B61-B60
  201. %V%%R%B62-B61
  202. %V%%R%B63-B62
  203. New Meter Installed
  204. %V%%R%B65-B64
  205. %CO:D,6,55%
  206.  
  207.  
  208. Btu's
  209. %V%%R%0
  210. %V%%R%vlookup(L6,[Gas_Rate]$A$1$A$21,3)
  211. %V%%R%vlookup(L7,[Gas_Rate]$A$1$A$21,3)
  212. %V%%R%vlookup(L8,[Gas_Rate]$A$1$A$21,3)
  213. %V%%R%vlookup(L9,[Gas_Rate]$A$1$A$21,3)
  214. %V%%R%vlookup(L10,[Gas_Rate]$A$1$A$21,3)
  215. %V%%R%vlookup(L11,[Gas_Rate]$A$1$A$21,3)
  216. %V%%R%vlookup(L12,[Gas_Rate]$A$1$A$21,3)
  217. %V%%R%vlookup(L13,[Gas_Rate]$A$1$A$21,3)
  218. %V%%R%vlookup(L14,[Gas_Rate]$A$1$A$21,3)
  219. %V%%R%vlookup(L15,[Gas_Rate]$A$1$A$21,3)
  220. %V%%R%vlookup(L16,[Gas_Rate]$A$1$A$21,3)
  221. %V%%R%vlookup(L17,[Gas_Rate]$A$1$A$21,3)
  222. %V%%R%vlookup(L18,[Gas_Rate]$A$1$A$21,3)
  223. %V%%R%vlookup(L19,[Gas_Rate]$A$1$A$21,3)
  224. %V%%R%vlookup(L20,[Gas_Rate]$A$1$A$21,3)
  225. %V%%R%vlookup(L21,[Gas_Rate]$A$1$A$21,3)
  226. %V%%R%vlookup(L22,[Gas_Rate]$A$1$A$21,3)
  227. %V%%R%vlookup(L23,[Gas_Rate]$A$1$A$21,3)
  228. %V%%R%vlookup(L24,[Gas_Rate]$A$1$A$21,3)
  229. %V%%R%vlookup(L25,[Gas_Rate]$A$1$A$21,3)
  230. %V%%R%vlookup(L26,[Gas_Rate]$A$1$A$21,3)
  231. %V%%R%vlookup(L27,[Gas_Rate]$A$1$A$21,3)
  232. %V%%R%vlookup(L28,[Gas_Rate]$A$1$A$21,3)
  233. %V%%R%vlookup(L29,[Gas_Rate]$A$1$A$21,3)
  234. %V%%R%vlookup(L30,[Gas_Rate]$A$1$A$21,3)
  235. %V%%R%vlookup(L31,[Gas_Rate]$A$1$A$21,3)
  236. %V%%R%vlookup(L32,[Gas_Rate]$A$1$A$21,3)
  237. %V%%R%1024
  238. %V%%R%vlookup(L34,[Gas_Rate]$A$1$A$21,3)
  239. %V%%R%1026
  240. %V%%R%1032
  241. %V%%R%1032
  242. %V%%R%1032
  243. %V%%R%vlookup(L39,[Gas_Rate]$A$1$A$21,3)
  244. %V%%R%vlookup(L40,[Gas_Rate]$A$1$A$21,3)
  245. %V%%R%vlookup(L41,[Gas_Rate]$A$1$A$21,3)
  246. %V%%R%vlookup(L42,[Gas_Rate]$A$1$A$21,3)
  247. %V%%R%vlookup(L43,[Gas_Rate]$A$1$A$21,3)
  248. %V%%R%vlookup(L44,[Gas_Rate]$A$1$A$21,3)
  249. %V%%R%vlookup(L45,[Gas_Rate]$A$1$A$21,3)
  250. %V%%R%vlookup(L46,[Gas_Rate]$A$1$A$21,3)
  251. %V%%R%vlookup(L47,[Gas_Rate]$A$1$A$21,3)
  252. %V%%R%vlookup(L48,[Gas_Rate]$A$1$A$21,3)
  253. %V%%R%vlookup(L49,[Gas_Rate]$A$1$A$21,3)
  254. %V%%R%vlookup(L50,[Gas_Rate]$A$1$A$21,3)
  255. %V%%R%vlookup(L51,[Gas_Rate]$A$1$A$21,3)
  256. %V%%R%vlookup(L52,[Gas_Rate]$A$1$A$21,3)
  257. %V%%R%vlookup(L53,[Gas_Rate]$A$1$A$21,3)
  258. %V%%R%vlookup(L54,[Gas_Rate]$A$1$A$21,3)
  259. %V%%R%1034
  260. %V%%R%vlookup(L56,[Gas_Rate]$A$1$A$21,3)
  261. %V%%R%vlookup(L57,[Gas_Rate]$A$1$A$21,3)
  262. %V%%R%1034
  263. %V%%R%1034
  264. %V%%R%vlookup(L60,[Gas_Rate]$A$1$A$29,3)
  265. %V%%R%1034
  266. %V%%R%1034
  267. %V%%R%1032
  268.  
  269. %V%%R%1032
  270. %CO:E,9,49%
  271.  
  272.  
  273.   Therms
  274. %V%%R%0
  275. %V%%R%%D3%C6*D6/1000
  276. %V%%R%%D3%C7*D7/1000
  277. %V%%R%%D3%C8*D8/1000
  278. %V%%R%%D3%C9*D9/1000
  279. %V%%R%%D3%C10*D10/1000
  280. %V%%R%%D3%C11*D11/1000
  281. %V%%R%%D3%C12*D12/1000
  282. %V%%R%%D3%C13*D13/1000
  283. %V%%R%%D3%C14*D14/1000
  284. %V%%R%%D3%C15*D15/1000
  285. %V%%R%%D3%C16*D16/1000
  286. %V%%R%%D3%C17*D17/1000
  287. %V%%R%%D3%C18*D18/1000
  288. %V%%R%%D3%C19*D19/1000
  289. %V%%R%%D3%C20*D20/1000
  290. %V%%R%%D3%C21*D21/1000
  291. %V%%R%%D3%C22*D22/1000
  292. %V%%R%%D3%C23*D23/1000
  293. %V%%R%%D3%C24*D24/1000
  294. %V%%R%%D3%C25*D25/1000
  295. %V%%R%%D3%C26*D26/1000
  296. %V%%R%%D3%C27*D27/1000
  297. %V%%R%%D3%C28*D28/1000
  298. %V%%R%%D3%C29*D29/1000
  299. %V%%R%%D3%C30*D30/1000
  300. %V%%R%%D3%C31*D31/1000
  301. %V%%R%%D3%C32*D32/1000
  302. %V%%R%%D3%C33*D33/1000
  303. %V%%R%%D3%C34*D34/1000
  304. %V%%R%%D3%C35*D35/1000
  305. %V%%R%%D3%C36*D36/1000
  306. %V%%R%%D3%C37*D37/1000
  307. %V%%R%%D3%C38*D38/1000
  308. %V%%R%%D3%C39*D39/1000
  309. %V%%R%%D3%C40*D40/1000
  310. %V%%R%%D3%C41*D41/1000
  311. %V%%R%%D3%C42*D42/1000
  312. %V%%R%%D3%C43*D43/1000
  313. %V%%R%%D3%C44*D44/1000
  314. %V%%R%%D3%C45*D45/1000
  315. %V%%R%%D3%C46*D46/1000
  316. %V%%R%%D3%C47*D47/1000
  317. %V%%R%%D3%C48*D48/1000
  318. %V%%R%%D3%C49*D49/1000
  319. %V%%R%%D3%C50*D50/1000
  320. %V%%R%%D3%C51*D51/1000
  321. %V%%R%%D3%C52*D52/1000
  322. %V%%R%%D3%C53*D53/1000
  323. %V%%R%%D3%C54*D54/1000
  324. %V%%R%%D3%C55*D55/1000
  325. %V%%R%%D3%C56*D56/1000
  326. %V%%R%%D3%C57*D57/1000
  327. %V%%R%%D3%C58*D58/1000
  328. %V%%R%%D3%C59*D59/1000
  329. %V%%R%%D3%C60*D60/1000
  330. %V%%R%%D3%C61*D61/1000
  331. %V%%R%%D3%C62*D62/1000
  332. %V%%R%%D3%C63*D63/1000
  333.  
  334. %V%%R%%D3%C65*D65/1000
  335. %CO:F,8,40%
  336.  
  337.   Pence
  338.  /Therm
  339. %V%%R%0
  340. %V%%R%%D3%vlookup(L6,[Gas_Rate]$A$1$A$21,1)
  341. %V%%R%%D3%vlookup(L7,[Gas_Rate]$A$1$A$21,1)
  342. %V%%R%%D3%vlookup(L8,[Gas_Rate]$A$1$A$21,1)
  343. %V%%R%%D3%vlookup(L9,[Gas_Rate]$A$1$A$21,1)
  344. %V%%R%%D3%vlookup(L10,[Gas_Rate]$A$1$A$21,1)
  345. %V%%R%%D3%vlookup(L11,[Gas_Rate]$A$1$A$21,1)
  346. %V%%R%%D3%vlookup(L12,[Gas_Rate]$A$1$A$21,1)
  347. %V%%R%%D3%vlookup(L13,[Gas_Rate]$A$1$A$21,1)
  348. %V%%R%%D3%vlookup(L14,[Gas_Rate]$A$1$A$21,1)
  349. %V%%R%%D3%vlookup(L15,[Gas_Rate]$A$1$A$21,1)
  350. %V%%R%%D3%vlookup(L16,[Gas_Rate]$A$1$A$21,1)
  351. %V%%R%%D3%vlookup(L17,[Gas_Rate]$A$1$A$21,1)
  352. %V%%R%%D3%vlookup(L18,[Gas_Rate]$A$1$A$21,1)
  353. %V%%R%%D3%vlookup(L19,[Gas_Rate]$A$1$A$21,1)
  354. %V%%R%%D3%vlookup(L20,[Gas_Rate]$A$1$A$21,1)
  355. %V%%R%%D3%vlookup(L21,[Gas_Rate]$A$1$A$21,1)
  356. %V%%R%%D3%vlookup(L22,[Gas_Rate]$A$1$A$21,1)
  357. %V%%R%%D3%vlookup(L23,[Gas_Rate]$A$1$A$21,1)
  358. %V%%R%%D3%vlookup(L24,[Gas_Rate]$A$1$A$21,1)
  359. %V%%R%%D3%vlookup(L25,[Gas_Rate]$A$1$A$21,1)
  360. %V%%R%%D3%vlookup(L26,[Gas_Rate]$A$1$A$21,1)
  361. %V%%R%%D3%vlookup(L27,[Gas_Rate]$A$1$A$21,1)
  362. %V%%R%%D3%vlookup(L28,[Gas_Rate]$A$1$A$21,1)
  363. %V%%R%%D3%vlookup(L29,[Gas_Rate]$A$1$A$21,1)
  364. %V%%R%%D3%vlookup(L30,[Gas_Rate]$A$1$A$21,1)
  365. %V%%R%%D3%vlookup(L31,[Gas_Rate]$A$1$A$21,1)
  366. %V%%R%%D3%vlookup(L32,[Gas_Rate]$A$1$A$21,1)
  367. %V%%R%%D3%vlookup(L33,[Gas_Rate]$A$1$A$21,1)
  368. %V%%R%%D3%vlookup(L34,[Gas_Rate]$A$1$A$21,1)
  369. %V%%R%%D3%vlookup(L35,[Gas_Rate]$A$1$A$21,1)
  370. %V%%R%%D3%vlookup(L36,[Gas_Rate]$A$1$A$21,1)
  371. %V%%R%%D3%vlookup(L37,[Gas_Rate]$A$1$A$21,1)
  372. %V%%R%%D3%vlookup(L38,[Gas_Rate]$A$1$A$21,1)
  373. %V%%R%%D3%vlookup(L39,[Gas_Rate]$A$1$A$21,1)
  374. %V%%R%%D3%vlookup(L40,[Gas_Rate]$A$1$A$21,1)
  375. %V%%R%%D3%vlookup(L41,[Gas_Rate]$A$1$A$21,1)
  376. %V%%R%%D3%vlookup(L42,[Gas_Rate]$A$1$A$21,1)
  377. %V%%R%%D3%vlookup(L43,[Gas_Rate]$A$1$A$21,1)
  378. %V%%R%%D3%vlookup(L44,[Gas_Rate]$A$1$A$21,1)
  379. %V%%R%%D3%vlookup(L45,[Gas_Rate]$A$1$A$21,1)
  380. %V%%R%%D3%vlookup(L46,[Gas_Rate]$A$1$A$21,1)
  381. %V%%R%%D3%vlookup(L47,[Gas_Rate]$A$1$A$21,1)
  382. %V%%R%%D3%vlookup(L48,[Gas_Rate]$A$1$A$21,1)
  383. %V%%R%%D3%vlookup(L49,[Gas_Rate]$A$1$A$21,1)
  384. %V%%R%%D3%vlookup(L50,[Gas_Rate]$A$1$A$21,1)
  385. %V%%R%%D3%vlookup(L51,[Gas_Rate]$A$1$A$21,1)
  386. %V%%R%%D3%vlookup(L52,[Gas_Rate]$A$1$A$21,1)
  387. %V%%R%%D3%vlookup(L53,[Gas_Rate]$A$1$A$21,1)
  388. %V%%R%%D3%vlookup(L54,[Gas_Rate]$A$1$A$21,1)
  389. %V%%R%%D3%vlookup(L55,[Gas_Rate]$A$1$A$21,1)
  390. %V%%R%%D3%vlookup(L56,[Gas_Rate]$A$1$A$21,1)
  391. %V%%R%%D3%vlookup(L57,[Gas_Rate]$A$1$A$21,1)
  392. %V%%R%%D3%vlookup(L58,[Gas_Rate]$A$1$A$21,1)
  393. %V%%R%%D3%vlookup(L59,[Gas_Rate]$A$1$A$21,1)
  394. %V%%R%%D3%vlookup(L60,[Gas_Rate]$A$1$A$21,1)
  395. %V%%R%%D3%vlookup(L61,[Gas_Rate]$A$1$A$21,1)
  396. %V%%R%%D3%vlookup(L62,[Gas_Rate]$A$1$A$21,1)
  397. %V%%R%%D3%vlookup(L63,[Gas_Rate]$A$1$A$21,1)
  398.  
  399. %V%%R%%D3%vlookup(L65,[Gas_Rate]$A$1$A$21,1)
  400. %CO:G,7,32%
  401.  
  402.  
  403.    Cost
  404. %V%%R%0
  405. %V%%R%%D2%round(E6*F6/100,1)
  406. %V%%R%%D2%round(E7*F7/100,1)
  407. %V%%R%%D2%round(E8*F8/100,2)
  408. %V%%R%%D2%round(E9*F9/100,2)
  409. %V%%R%%D2%round(E10*F10/100,2)
  410. %V%%R%%D2%round(E11*F11/100,2)
  411. %V%%R%%D2%round(((E12-52)*F12+(52*22.8))/100,2)
  412. %V%%R%%D2%round(((E13-52)*F13+(52*22.8))/100,2)
  413. %V%%R%%D2%round(((E14-52)*F14+(52*22.8))/100,2)
  414. %V%%R%%D2%round(((E15-52)*F15+(52*22.8))/100,2)
  415. %V%%R%%D2%round(((E16-52)*F16+(52*22.8))/100,2)
  416. %V%%R%%D2%round(((E17-52)*F17+(52*22.8))/100,2)
  417. %V%%R%%D2%round(((E18-52)*F18+(52*22.8))/100,2)
  418. %V%%R%%D2%round(((E19-52)*F19+(52*22.8))/100,2)
  419. %V%%R%%D2%round(((E20-52)*F20+(52*22.8))/100,2)
  420. %V%%R%%D2%round(((E21-52)*F21+(52*24.6))/100,2)
  421. %V%%R%%D2%round(((E22-52)*F22+(52*24.6))/100,2)
  422. %V%%R%%D2%round(((E23-52)*F23+(52*24.6))/100,2)
  423. %V%%R%%D2%round(((E24-52)*F24+(52*24.6))/100,2)
  424. %V%%R%%D2%round(((E25-52)*F25+(52*24.6))/100,2)
  425. %V%%R%%D2%round(((E26-52)*F26+(52*24.6))/100,2)
  426. %V%%R%%D2%round(((E27-52)*F27+(52*24.6))/100,2)
  427. %V%%R%%D2%round(((E28-52)*F28+(52*24.6))/100,2)
  428. %V%%R%%D2%round(E29*F29/100,2)
  429. %V%%R%%D2%round(E30*F30/100,2)
  430. %V%%R%%D2%round(E31*F31/100,2)
  431. %V%%R%%D2%round(E32*F32/100,2)
  432. %V%%R%%D2%round(E33*F33/100,2)
  433. %V%%R%%D2%round(E34*F34/100,2)
  434. %V%%R%%D2%round(E35*F35/100,2)
  435. %V%%R%%D2%round(E36*F36/100,2)
  436. %V%%R%%D2%round(E37*F37/100,2)
  437. %V%%R%%D2%round(E38*F38/100,2)
  438. %V%%R%%D2%round(E39*F39/100,2)
  439. %V%%R%%D2%round(E40*F40/100,2)
  440. %V%%R%%D2%round(E41*F41/100,2)
  441. %V%%R%%D2%round(E42*F42/100,2)
  442. %V%%R%%D2%round(E43*F43/100,2)
  443. %V%%R%%D2%round(E44*F44/100,2)
  444. %V%%R%%D2%round(E45*F45/100,2)
  445. %V%%R%%D2%round(E46*F46/100,2)
  446. %V%%R%%D2%round(E47*F47/100,2)
  447. %V%%R%%D2%round(E48*F48/100,2)
  448. %V%%R%%D2%round(E49*F49/100,2)
  449. %V%%R%%D2%round(E50*F50/100,2)
  450. %V%%R%%D2%round(E51*F51/100,2)
  451. %V%%R%%D2%round(E52*F52/100,2)
  452. %V%%R%%D2%round(E53*F53/100,2)
  453. %V%%R%%D2%round(E54*F54/100,2)
  454. %V%%R%%D2%round(E55*F55/100,2)
  455. %V%%R%%D2%round(E56*F56/100,2)
  456. %V%%R%%D2%round(E57*F57/100,2)
  457. %V%%R%%D2%round(E58*F58/100,2)
  458. %V%%R%%D2%round(E59*F59/100,2)
  459. %V%%R%%D2%round(E60*F60/100,2)
  460. %V%%R%%D2%round(E61*F61/100,2)
  461. %V%%R%%D2%round(E62*F62/100,2)
  462. %V%%R%%D2%round(E63*F63/100,2)
  463.  
  464. %V%%R%%D2%round(E65*F65/100,2)
  465. %CO:H,7,25%
  466.  
  467. %L% Standg
  468.  Charge
  469. %V%%R%0
  470. %V%%R%%D2%vlookup(L6,[Gas_Rate]$A$1$A$21,2)
  471. %V%%R%%D2%2.12
  472. %V%%R%%D2%vlookup(L8,[Gas_Rate]$A$1$A$21,2)
  473. %V%%R%%D2%vlookup(L9,[Gas_Rate]$A$1$A$21,2)
  474. %V%%R%%D2%vlookup(L10,[Gas_Rate]$A$1$A$21,2)
  475. %V%%R%%D2%vlookup(L11,[Gas_Rate]$A$1$A$21,2)
  476. %V%%R%%D2%vlookup(L12,[Gas_Rate]$A$1$A$21,2)
  477. %V%%R%%D2%vlookup(L13,[Gas_Rate]$A$1$A$21,2)
  478. %V%%R%%D2%vlookup(L14,[Gas_Rate]$A$1$A$21,2)
  479. %V%%R%%D2%vlookup(L15,[Gas_Rate]$A$1$A$21,2)
  480. %V%%R%%D2%vlookup(L16,[Gas_Rate]$A$1$A$21,2)
  481. %V%%R%%D2%vlookup(L17,[Gas_Rate]$A$1$A$21,2)
  482. %V%%R%%D2%vlookup(L18,[Gas_Rate]$A$1$A$21,2)
  483. %V%%R%%D2%vlookup(L19,[Gas_Rate]$A$1$A$21,2)
  484. %V%%R%%D2%vlookup(L20,[Gas_Rate]$A$1$A$21,2)
  485. %V%%R%%D2%vlookup(L21,[Gas_Rate]$A$1$A$21,2)
  486. %V%%R%%D2%vlookup(L22,[Gas_Rate]$A$1$A$21,2)
  487. %V%%R%%D2%vlookup(L23,[Gas_Rate]$A$1$A$21,2)
  488. %V%%R%%D2%vlookup(L24,[Gas_Rate]$A$1$A$21,2)
  489. %V%%R%%D2%vlookup(L25,[Gas_Rate]$A$1$A$21,2)
  490. %V%%R%%D2%vlookup(L26,[Gas_Rate]$A$1$A$21,2)
  491. %V%%R%%D2%vlookup(L27,[Gas_Rate]$A$1$A$21,2)
  492. %V%%R%%D2%vlookup(L28,[Gas_Rate]$A$1$A$21,2)
  493. %V%%R%%D2%vlookup(L29,[Gas_Rate]$A$1$A$21,2)
  494. %V%%R%%D2%vlookup(L30,[Gas_Rate]$A$1$A$21,2)
  495. %V%%R%%D2%vlookup(L31,[Gas_Rate]$A$1$A$21,2)
  496. %V%%R%%D2%vlookup(L32,[Gas_Rate]$A$1$A$21,2)
  497. %V%%R%%D2%vlookup(L33,[Gas_Rate]$A$1$A$21,2)
  498. %V%%R%%D2%vlookup(L34,[Gas_Rate]$A$1$A$21,2)
  499. %V%%R%%D2%vlookup(L35,[Gas_Rate]$A$1$A$21,2)
  500. %V%%R%%D2%vlookup(L36,[Gas_Rate]$A$1$A$21,2)
  501. %V%%R%%D2%vlookup(L37,[Gas_Rate]$A$1$A$21,2)
  502. %V%%R%%D2%12.95
  503. %V%%R%%D2%6.09
  504. %V%%R%%D2%vlookup(L40,[Gas_Rate]$A$1$A$21,2)
  505. %V%%R%%D2%vlookup(L41,[Gas_Rate]$A$1$A$21,2)
  506. %V%%R%%D2%vlookup(L42,[Gas_Rate]$A$1$A$21,2)
  507. %V%%R%%D2%20.56
  508. %V%%R%%D2%8.01
  509. %V%%R%%D2%vlookup(L45,[Gas_Rate]$A$1$A$21,2)
  510. %V%%R%%D2%vlookup(L46,[Gas_Rate]$A$1$A$21,2)
  511. %V%%R%%D2%vlookup(L47,[Gas_Rate]$A$1$A$21,2)
  512. %V%%R%%D2%vlookup(L48,[Gas_Rate]$A$1$A$21,2)
  513. %V%%R%%D2%vlookup(L49,[Gas_Rate]$A$1$A$21,2)
  514. %V%%R%%D2%2.74
  515. %V%%R%%D2%6.16
  516. %V%%R%%D2%vlookup(L52,[Gas_Rate]$A$1$A$21,2)
  517. %V%%R%%D2%vlookup(L53,[Gas_Rate]$A$1$A$21,2)
  518. %V%%R%%D2%vlookup(L54,[Gas_Rate]$A$1$A$21,2)
  519. %V%%R%%D2%vlookup(L55,[Gas_Rate]$A$1$A$21,2)
  520. %V%%R%%D2%vlookup(L56,[Gas_Rate]$A$1$A$21,2)
  521. %V%%R%%D2%vlookup(L57,[Gas_Rate]$A$1$A$21,2)
  522. %V%%R%%D2%vlookup(L58,[Gas_Rate]$A$1$A$21,2)
  523. %V%%R%%D2%vlookup(L59,[Gas_Rate]$A$1$A$21,2)
  524. %V%%R%%D2%vlookup(L60,[Gas_Rate]$A$1$A$21,2)
  525. %V%%R%%D2%vlookup(L61,[Gas_Rate]$A$1$A$21,2)
  526. %V%%R%%D2%vlookup(L62,[Gas_Rate]$A$1$A$21,2)
  527. %V%%R%%D2%vlookup(L63,[Gas_Rate]$A$1$A$21,2)
  528.  
  529. %V%%R%%D2%vlookup(L65,[Gas_Rate]$A$1$A$21,2)
  530. %CO:I,7,18%
  531.  
  532.  
  533.  TOTAL
  534. %V%%R%0
  535. %V%%R%%D2%G6+H6
  536. %V%%R%%D2%G7+H7
  537. %V%%R%%D2%G8+H8
  538. %V%%R%%D2%G9+H9
  539. %V%%R%%D2%G10+H10
  540. %V%%R%%D2%G11+H11
  541. %V%%R%%D2%G12+H12
  542. %V%%R%%D2%G13+H13
  543. %V%%R%%D2%G14+H14
  544. %V%%R%%D2%G15+H15
  545. %V%%R%%D2%G16+H16
  546. %V%%R%%D2%G17+H17
  547. %V%%R%%D2%G18+H18
  548. %V%%R%%D2%G19+H19
  549. %V%%R%%D2%G20+H20
  550. %V%%R%%D2%G21+H21
  551. %V%%R%%D2%G22+H22
  552. %V%%R%%D2%G23+H23
  553. %V%%R%%D2%G24+H24
  554. %V%%R%%D2%G25+H25
  555. %V%%R%%D2%G26+H26
  556. %V%%R%%D2%G27+H27
  557. %V%%R%%D2%G28+H28
  558. %V%%R%%D2%G29+H29
  559. %V%%R%%D2%G30+H30
  560. %V%%R%%D2%G31+H31
  561. %V%%R%%D2%G32+H32
  562. %V%%R%%D2%G33+H33
  563. %V%%R%%D2%G34+H34
  564. %V%%R%%D2%G35+H35
  565. %V%%R%%D2%G36+H36
  566. %V%%R%%D2%G37+H37
  567. %V%%R%%D2%G38+H38
  568. %V%%R%%D2%G39+H39
  569. %V%%R%%D2%G40+H40
  570. %V%%R%%D2%G41+H41
  571. %V%%R%%D2%G42+H42
  572. %V%%R%%D2%G43+H43
  573. %V%%R%%D2%G44+H44
  574. %V%%R%%D2%G45+H45
  575. %V%%R%%D2%G46+H46
  576. %V%%R%%D2%G47+H47
  577. %V%%R%%D2%G48+H48
  578. %V%%R%%D2%G49+H49
  579. %V%%R%%D2%G50+H50
  580. %V%%R%%D2%G51+H51
  581. %V%%R%%D2%G52+H52
  582. %V%%R%%D2%G53+H53
  583. %V%%R%%D2%G54+H54
  584. %V%%R%%D2%G55+H55
  585. %V%%R%%D2%G56+H56
  586. %V%%R%%D2%G57+H57
  587. %V%%R%%D2%G58+H58
  588. %V%%R%%D2%G59+H59
  589. %V%%R%%D2%G60+H60
  590. %V%%R%%D2%G61+H61
  591. %V%%R%%D2%G62+H62
  592. %V%%R%%D2%G63+H63
  593.  
  594. %V%%R%%D2%G65+H65
  595. %CO:J,6,11%
  596.  
  597. Annual
  598. Usage
  599. %V%%R%0
  600.  
  601.  
  602.  
  603. %V%%R%sum(E6E9)
  604.  
  605.  
  606.  
  607. %V%%R%sum(E10E13)
  608.  
  609.  
  610.  
  611. %V%%R%sum(E14E17)
  612.  
  613.  
  614.  
  615. %V%%R%sum(E18E21)
  616.  
  617.  
  618.  
  619. %V%%R%sum(E22E25)
  620.  
  621.  
  622.  
  623. %V%%R%sum(E26E29)
  624.  
  625.  
  626.  
  627. %V%%R%sum(E30E33)
  628.  
  629.  
  630.  
  631. %V%%R%sum(E34E37)
  632.  
  633.  
  634.  
  635. %V%%R%sum(E38E41)
  636.  
  637.  
  638. %V%%R%sum(E42E44)
  639.  
  640.  
  641.  
  642. %V%%R%sum(E45E48)
  643.  
  644.  
  645.  
  646.  
  647. %V%%R%sum(E49E53)
  648.  
  649.  
  650.  
  651. %V%%R%sum(E54E57)
  652.  
  653.  
  654.  
  655. %V%%R%sum(E58E61)
  656. %CO:K,5,5%
  657.  
  658.  
  659. Year
  660. %V%%R%1975
  661.  
  662.  
  663.  
  664. %V%%R%1976
  665.  
  666.  
  667.  
  668. %V%%R%1977
  669.  
  670.  
  671.  
  672. %V%%R%1978
  673.  
  674.  
  675.  
  676. %V%%R%1979
  677.  
  678.  
  679.  
  680. %V%%R%1980
  681.  
  682.  
  683.  
  684. %V%%R%1981
  685.  
  686.  
  687.  
  688. %V%%R%1982
  689.  
  690.  
  691.  
  692. %V%%R%1983
  693.  
  694.  
  695.  
  696. %V%%R%1984
  697.  
  698.  
  699. %V%%R%1985
  700.  
  701.  
  702.  
  703. %V%%R%1986
  704.  
  705.  
  706.  
  707.  
  708. %V%%R%1987
  709.  
  710.  
  711.  
  712. %V%%R%1988
  713.  
  714.  
  715.  
  716. %V%%R%1989
  717. %CO:L,7,0%
  718.  
  719.  
  720. YYMMDD
  721. %V%%R%(year(A5))*10000+(month(A5))*100+(day(A5))
  722. %V%%R%(year(A6))*10000+(month(A6))*100+(day(A6))
  723. %V%%R%(year(A7))*10000+(month(A7))*100+(day(A7))
  724. %V%%R%(year(A8))*10000+(month(A8))*100+(day(A8))
  725. %V%%R%(year(A9))*10000+(month(A9))*100+(day(A9))
  726. %V%%R%(year(A10))*10000+(month(A10))*100+(day(A10))
  727. %V%%R%(year(A11))*10000+(month(A11))*100+(day(A11))
  728. %V%%R%(year(A12))*10000+(month(A12))*100+(day(A12))
  729. %V%%R%(year(A13))*10000+(month(A13))*100+(day(A13))
  730. %V%%R%(year(A14))*10000+(month(A14))*100+(day(A14))
  731. %V%%R%(year(A15))*10000+(month(A15))*100+(day(A15))
  732. %V%%R%(year(A16))*10000+(month(A16))*100+(day(A16))
  733. %V%%R%(year(A17))*10000+(month(A17))*100+(day(A17))
  734. %V%%R%(year(A18))*10000+(month(A18))*100+(day(A18))
  735. %V%%R%(year(A19))*10000+(month(A19))*100+(day(A19))
  736. %V%%R%(year(A20))*10000+(month(A20))*100+(day(A20))
  737. %V%%R%(year(A21))*10000+(month(A21))*100+(day(A21))
  738. %V%%R%(year(A22))*10000+(month(A22))*100+(day(A22))
  739. %V%%R%(year(A23))*10000+(month(A23))*100+(day(A23))
  740. %V%%R%(year(A24))*10000+(month(A24))*100+(day(A24))
  741. %V%%R%(year(A25))*10000+(month(A25))*100+(day(A25))
  742. %V%%R%(year(A26))*10000+(month(A26))*100+(day(A26))
  743. %V%%R%(year(A27))*10000+(month(A27))*100+(day(A27))
  744. %V%%R%(year(A28))*10000+(month(A28))*100+(day(A28))
  745. %V%%R%(year(A29))*10000+(month(A29))*100+(day(A29))
  746. %V%%R%(year(A30))*10000+(month(A30))*100+(day(A30))
  747. %V%%R%(year(A31))*10000+(month(A31))*100+(day(A31))
  748. %V%%R%(year(A32))*10000+(month(A32))*100+(day(A32))
  749. %V%%R%(year(A33))*10000+(month(A33))*100+(day(A33))
  750. %V%%R%(year(A34))*10000+(month(A34))*100+(day(A34))
  751. %V%%R%(year(A35))*10000+(month(A35))*100+(day(A35))
  752. %V%%R%(year(A36))*10000+(month(A36))*100+(day(A36))
  753. %V%%R%(year(A37))*10000+(month(A37))*100+(day(A37))
  754. %V%%R%(year(A38))*10000+(month(A38))*100+(day(A38))
  755. %V%%R%(year(A39))*10000+(month(A39))*100+(day(A39))
  756. %V%%R%(year(A40))*10000+(month(A40))*100+(day(A40))
  757. %V%%R%(year(A41))*10000+(month(A41))*100+(day(A41))
  758. %V%%R%(year(A42))*10000+(month(A42))*100+(day(A42))
  759. %V%%R%(year(A43))*10000+(month(A43))*100+(day(A43))
  760. %V%%R%(year(A44))*10000+(month(A44))*100+(day(A44))
  761. %V%%R%(year(A45))*10000+(month(A45))*100+(day(A45))
  762. %V%%R%(year(A46))*10000+(month(A46))*100+(day(A46))
  763. %V%%R%(year(A47))*10000+(month(A47))*100+(day(A47))
  764. %V%%R%(year(A48))*10000+(month(A48))*100+(day(A48))
  765. %V%%R%(year(A49))*10000+(month(A49))*100+(day(A49))
  766. %V%%R%(year(A50))*10000+(month(A50))*100+(day(A50))
  767. %V%%R%(year(A51))*10000+(month(A51))*100+(day(A51))
  768. %V%%R%(year(A52))*10000+(month(A52))*100+(day(A52))
  769. %V%%R%(year(A53))*10000+(month(A53))*100+(day(A53))
  770. %V%%R%(year(A54))*10000+(month(A54))*100+(day(A54))
  771. %V%%R%(year(A55))*10000+(month(A55))*100+(day(A55))
  772. %V%%R%(year(A56))*10000+(month(A56))*100+(day(A56))
  773. %V%%R%(year(A57))*10000+(month(A57))*100+(day(A57))
  774. %V%%R%(year(A58))*10000+(month(A58))*100+(day(A58))
  775. %V%%R%(year(A59))*10000+(month(A59))*100+(day(A59))
  776. %V%%R%(year(A60))*10000+(month(A60))*100+(day(A60))
  777. %V%%R%(year(A61))*10000+(month(A61))*100+(day(A61))
  778. %V%%R%(year(A62))*10000+(month(A62))*100+(day(A62))
  779. %V%%R%(year(A63))*10000+(month(A63))*100+(day(A63))
  780. %V%%R%(year(A64))*10000+(month(A64))*100+(day(A64))
  781. %V%%R%(year(A65))*10000+(month(A65))*100+(day(A65))
  782.